Overview

Dataset info

Number of variables40
Number of observations13525
Missing cells100681 (18.6%)
Duplicate rows0 (0.0%)
Total size in memory4.1 MiB
Average record size in memory320.0 B

Variables types

Numeric8
Categorical14
Boolean11
Date0
URL0
Text (Unique)1
Rejected6
Unsupported0

Warnings

Black.Friday has 5950 (44.0%) missing values Missing
Christmas.Flag has 5950 (44.0%) missing values Missing
Discount_final has a high cardinality: 71 distinct values Warning
Event has 12727 (94.1%) missing values Missing
FB_Spends has 5429 (40.1%) zeros Zeros
FB_Spends_Adstock_0.173 is highly correlated with FB_Spends (ρ = 0.9913990349) Rejected
Festival.Flag has 5950 (44.0%) missing values Missing
Fiscal_Week is highly correlated with Fiscal_Month (ρ = 0.9966852518) Rejected
Free.Trial.Week has 5950 (44.0%) missing values Missing
Free.Trial.Week.Lag1 has 5950 (44.0%) missing values Missing
Free.Trial.Week.Lag2 has 11724 (86.7%) missing values Missing
game_name has constant value "Mortal Kombat 11" Rejected
geo_region has constant value "North America" Rejected
Halloween has 5950 (44.0%) missing values Missing
Holiday has 5950 (44.0%) missing values Missing
New_Week_Since_Launch is highly correlated with days_since_launch (ρ = 0.9998798641) Rejected
Post.Holiday.Flag has 5950 (44.0%) missing values Missing
Pre.Holiday.Flag has 5950 (44.0%) missing values Missing
Price has 11724 (86.7%) missing values Missing
Promo has 10774 (79.7%) missing values Missing
pweek has a high cardinality: 2178 distinct values Warning
revenue_usd is highly skewed (γ1 = 21.3810817) Skewed
transaction_date has a high cardinality: 483 distinct values Warning
units_base has 182 (1.3%) missing values Missing
units_sold is highly correlated with revenue_usd (ρ = 0.9636180616) Rejected

Variables

asp_new
Numeric

Distinct count7537
Unique (%)55.7%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean42.04411673
Minimum3.9641
Maximum252.189
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum3.9641
5-th percentile16.03621327
Q127.73038333
Median41.993
Q362.3525
95-th percentile70.33503792
Maximum252.189
Range248.2249
Interquartile range34.62211667

Descriptive statistics

Standard deviation18.52068936
Coef of variation0.4405060874
Kurtosis0.7757323968
Mean42.04411673
MAD14.94142997
Skewness0.5257290451
Sum568646.6787
Variance343.0159343
Memory size105.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 3.9641 8.827 8.93153692 10.36190526 10.51907219 ... 73.91218782 73.91226818 75.853883 87.4055 252.189 ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
41.993 1162 8.6%
 
27.993 1001 7.4%
 
69.993 831 6.1%
 
62.993 353 2.6%
 
16.793 119 0.9%
 
25.193 102 0.8%
 
31.493 79 0.6%
 
11.193 63 0.5%
 
50.393 63 0.5%
 
37.793 58 0.4%
 
Other values (7527) 9694 71.7%
 

Minimum 5 values

ValueCountFrequency (%) 
3.9641 1 < 0.1%
 
4.193 2 < 0.1%
 
7.9604 1 < 0.1%
 
8.1165 1 < 0.1%
 
8.14048 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
252.189 1 < 0.1%
 
176.393 2 < 0.1%
 
167.993 1 < 0.1%
 
119.693 5 < 0.1%
 
104.412 1 < 0.1%
 

base_asp
Numeric

Distinct count33
Unique (%)0.2%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean47.62926998
Minimum3.9641
Maximum73.96371903
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum3.9641
5-th percentile26.03813545
Q128.24724427
Median41.99333519
Q367.75479812
95-th percentile72.69908693
Maximum73.96371903
Range69.99961903
Interquartile range39.50755385

Descriptive statistics

Standard deviation17.30313431
Coef of variation0.3632878335
Kurtosis-1.440557296
Mean47.62926998
MAD15.16018546
Skewness0.2463963658
Sum644185.8765
Variance299.3984568
Memory size105.8 KiB
Histogram
Histogram with fixed size bins (bins=33)
Histogram
Histogram with variable size bins (bins=[ 3.9641 13.175085 23.678585 25.53162571 25.95069344 ... 69.30594565 71.1723971 72.52544056 73.33140298 73.96371903], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
69.993 1745 12.9%
 
27.993 1366 10.1%
 
41.993 1305 9.6%
 
72.69908693 482 3.6%
 
43.54733751 482 3.6%
 
41.99333519 482 3.6%
 
42.27351194 481 3.6%
 
41.68006598 472 3.5%
 
68.6188913 459 3.4%
 
47.02866623 458 3.4%
 
Other values (23) 5793 42.8%
 

Minimum 5 values

ValueCountFrequency (%) 
3.9641 1 < 0.1%
 
4.193 2 < 0.1%
 
22.15717 119 0.9%
 
25.2 97 0.7%
 
25.86325143 305 2.3%
 

Maximum 5 values

ValueCountFrequency (%) 
73.96371903 234 1.7%
 
72.69908693 482 3.6%
 
72.3517942 423 3.1%
 
69.993 1745 12.9%
 
68.6188913 459 3.4%
 

Black.Friday
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)44.0%
Missing (n)5950
0
7342
1
 
233
(Missing)
5950
ValueCountFrequency (%) 
0 7342 54.3%
 
1 233 1.7%
 
(Missing) 5950 44.0%
 

Christmas.Flag
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)44.0%
Missing (n)5950
0
7108
1
 
467
(Missing)
5950
ValueCountFrequency (%) 
0 7108 52.6%
 
1 467 3.5%
 
(Missing) 5950 44.0%
 

day_of_Week
Categorical

Distinct count7
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
Saturday
1989
Sunday
1962
Friday
1955
Other values (4)
7619
ValueCountFrequency (%) 
Saturday 1989 14.7%
 
Sunday 1962 14.5%
 
Friday 1955 14.5%
 
Thursday 1914 14.2%
 
Tuesday 1911 14.1%
 
Wednesday 1898 14.0%
 
Monday 1896 14.0%
 
Max length9
Mean length7.139445471
Min length6
Contains charsTrue
Contains digitsFalse
Contains spacesFalse
Contains non-wordsFalse

days_since_launch
Numeric

Distinct count483
Unique (%)3.6%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean129.2476895
Minimum-138
Maximum344
Zeros (%)0.3%
Mini histogram

Quantile statistics

Minimum-138
5-th percentile-93
Q129
Median132
Q3240
95-th percentile324
Maximum344
Range482
Interquartile range211

Descriptive statistics

Standard deviation128.435569
Coef of variation0.9937165569
Kurtosis-1.00122549
Mean129.2476895
MAD109.6897266
Skewness-0.1589176913
Sum1748075
Variance16495.69537
Memory size105.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[-138. -15.5 -1.5 75.5 344. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
277 39 0.3%
 
250 39 0.3%
 
233 39 0.3%
 
235 38 0.3%
 
245 38 0.3%
 
243 38 0.3%
 
251 38 0.3%
 
234 38 0.3%
 
248 38 0.3%
 
247 38 0.3%
 
Other values (473) 13142 97.2%
 

Minimum 5 values

ValueCountFrequency (%) 
-138 4 < 0.1%
 
-137 11 0.1%
 
-136 12 0.1%
 
-135 11 0.1%
 
-134 10 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
344 7 0.1%
 
343 33 0.2%
 
342 35 0.3%
 
341 33 0.2%
 
340 34 0.3%
 

Discount_final
Categorical

Distinct count71
Unique (%)0.5%
Missing (%)0.0%
Missing (n)0
0%
9159
60%
 
717
50%
 
620
Other values (68)
3029
ValueCountFrequency (%) 
0% 9159 67.7%
 
60% 717 5.3%
 
50% 620 4.6%
 
40% 479 3.5%
 
10% 469 3.5%
 
25% 165 1.2%
 
59% 158 1.2%
 
17% 145 1.1%
 
15% 115 0.9%
 
67% 106 0.8%
 
Other values (61) 1392 10.3%
 
Max length3
Mean length2.298262477
Min length2
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

dlc_event_flag
Boolean

Distinct count2
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
0
12727
1
 
798
ValueCountFrequency (%) 
0 12727 94.1%
 
1 798 5.9%
 

Event
Categorical

Distinct count25
Unique (%)0.2%
Missing (%)94.1%
Missing (n)12727
christmas
 
38
spawn launch
 
37
joker launch
 
37
Other values (21)
 
686
(Missing)
12727
ValueCountFrequency (%) 
christmas 38 0.3%
 
spawn launch 37 0.3%
 
joker launch 37 0.3%
 
shangtsung gameplay trailer 36 0.3%
 
shangtsung launch 36 0.3%
 
spawn early access 35 0.3%
 
spawn gameplay trailer 35 0.3%
 
sindel early access 34 0.3%
 
sindel launch 34 0.3%
 
klassic bundles update 34 0.3%
 
Other values (14) 442 3.3%
 
(Missing) 12727 94.1%
 
Max length27
Mean length3.93064695
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

F_Key
Categorical, Unique

First 5 values
Matinee Skin Pack-Game-Steam-North America-Canada-341
Matinee Skin Pack-Game-Steam-North America-United States-336
Matinee Skin Pack-Game-Steam-North America-United States-339
Mortal Kombat 11 - Kombat Pack-DLC-PS4-North America-Canada--1
Mortal Kombat 11 - Kombat Pack-DLC-PS4-North America-Canada-0
Last 5 values
Mortal Kombat 11-Game-XB1-North America-United States-95
Mortal Kombat 11-Game-XB1-North America-United States-96
Mortal Kombat 11-Game-XB1-North America-United States-97
Mortal Kombat 11-Game-XB1-North America-United States-98
Mortal Kombat 11-Game-XB1-North America-United States-99

First 5 values

ValueCountFrequency (%) 
Matinee Skin Pack-Game-Steam-North America-Canada-341 1 < 0.1%
 
Matinee Skin Pack-Game-Steam-North America-United States-336 1 < 0.1%
 
Matinee Skin Pack-Game-Steam-North America-United States-339 1 < 0.1%
 
Mortal Kombat 11 - Kombat Pack-DLC-PS4-North America-Canada--1 1 < 0.1%
 
Mortal Kombat 11 - Kombat Pack-DLC-PS4-North America-Canada-0 1 < 0.1%
 

Last 5 values

ValueCountFrequency (%) 
Mortal Kombat 11-Game-XB1-North America-United States-99 1 < 0.1%
 
Mortal Kombat 11-Game-XB1-North America-United States-98 1 < 0.1%
 
Mortal Kombat 11-Game-XB1-North America-United States-97 1 < 0.1%
 
Mortal Kombat 11-Game-XB1-North America-United States-96 1 < 0.1%
 
Mortal Kombat 11-Game-XB1-North America-United States-95 1 < 0.1%
 

FB_Spends
Numeric

Distinct count248
Unique (%)1.8%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean6706.381442
Minimum0
Maximum76440
Zeros (%)40.1%
Mini histogram

Quantile statistics

Minimum0
5-th percentile0
Q10
Median2522
Q38439
95-th percentile24545
Maximum76440
Range76440
Interquartile range8439

Descriptive statistics

Standard deviation11578.62181
Coef of variation1.726508089
Kurtosis14.09422174
Mean6706.381442
MAD7053.365247
Skewness3.441590292
Sum90703809
Variance134064483
Memory size105.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[ 0. 106. 766. 1055.5 1073.5 ... 62597.5 62946. 64257. 76140. 76440. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 5429 40.1%
 
7840 71 0.5%
 
2883 38 0.3%
 
7978 38 0.3%
 
7930 38 0.3%
 
212 38 0.3%
 
47214 38 0.3%
 
1321 37 0.3%
 
24545 37 0.3%
 
3879 37 0.3%
 
Other values (238) 7724 57.1%
 

Minimum 5 values

ValueCountFrequency (%) 
0 5429 40.1%
 
212 38 0.3%
 
744 33 0.2%
 
788 31 0.2%
 
892 29 0.2%
 

Maximum 5 values

ValueCountFrequency (%) 
76440 36 0.3%
 
75840 36 0.3%
 
65279 34 0.3%
 
63235 35 0.3%
 
62657 35 0.3%
 

FB_Spends_Adstock_0.173
Highly correlated

This variable is highly correlated with FB_Spends and should be ignored for analysis

Correlation0.9913990349

Festival.Flag
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)44.0%
Missing (n)5950
0
6488
1
 
1087
(Missing)
5950
ValueCountFrequency (%) 
0 6488 48.0%
 
1 1087 8.0%
 
(Missing) 5950 44.0%
 

Fiscal_Month
Numeric

Distinct count12
Unique (%)0.1%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean6.194898336
Minimum1
Maximum12
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum1
5-th percentile1
Q13
Median6
Q39
95-th percentile12
Maximum12
Range11
Interquartile range6

Descriptive statistics

Standard deviation3.650655883
Coef of variation0.5893003702
Kurtosis-1.30107779
Mean6.194898336
MAD3.19772103
Skewness0.1391317607
Sum83786
Variance13.32728838
Memory size105.8 KiB
Histogram
Histogram with fixed size bins (bins=12)
Histogram
Histogram with variable size bins (bins=[ 1. 1.5 2.5 3.5 4.5 8.5 11.5 12. ], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
3 1573 11.6%
 
1 1508 11.1%
 
12 1429 10.6%
 
2 1329 9.8%
 
5 1056 7.8%
 
6 1042 7.7%
 
10 1027 7.6%
 
8 996 7.4%
 
7 992 7.3%
 
11 906 6.7%
 
Other values (2) 1667 12.3%
 

Minimum 5 values

ValueCountFrequency (%) 
1 1508 11.1%
 
2 1329 9.8%
 
3 1573 11.6%
 
4 786 5.8%
 
5 1056 7.8%
 

Maximum 5 values

ValueCountFrequency (%) 
12 1429 10.6%
 
11 906 6.7%
 
10 1027 7.6%
 
9 881 6.5%
 
8 996 7.4%
 

Fiscal_Week
Highly correlated

This variable is highly correlated with Fiscal_Month and should be ignored for analysis

Correlation0.9966852518

Fiscal_Year
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
2019
10226
2020
2926
2018
 
373
ValueCountFrequency (%) 
2019 10226 75.6%
 
2020 2926 21.6%
 
2018 373 2.8%
 
Max length4
Mean length4
Min length4
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Free.Trial.Week
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)44.0%
Missing (n)5950
0
7503
1
 
72
(Missing)
5950
ValueCountFrequency (%) 
0 7503 55.5%
 
1 72 0.5%
 
(Missing) 5950 44.0%
 

Free.Trial.Week.Lag1
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)44.0%
Missing (n)5950
0
7459
1
 
116
(Missing)
5950
ValueCountFrequency (%) 
0 7459 55.1%
 
1 116 0.9%
 
(Missing) 5950 44.0%
 

Free.Trial.Week.Lag2
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)86.7%
Missing (n)11724
0
 
1787
1
 
14
(Missing)
11724
ValueCountFrequency (%) 
0 1787 13.2%
 
1 14 0.1%
 
(Missing) 11724 86.7%
 

game_name
Constant

This variable is constant and should be ignored for analysis

Constant valueMortal Kombat 11

geo_region
Constant

This variable is constant and should be ignored for analysis

Constant valueNorth America

geo_subregion
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
United States
5071
Canada
4497
Mexico
3936
ValueCountFrequency (%) 
United States 5071 37.5%
 
Canada 4497 33.2%
 
Mexico 3936 29.1%
 
Other NA 21 0.2%
 
Max length13
Mean length8.627652495
Min length6
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

Halloween
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)44.0%
Missing (n)5950
0
7188
1
 
387
(Missing)
5950
ValueCountFrequency (%) 
0 7188 53.1%
 
1 387 2.9%
 
(Missing) 5950 44.0%
 

Holiday
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)44.0%
Missing (n)5950
0
7521
1
 
54
(Missing)
5950
ValueCountFrequency (%) 
0 7521 55.6%
 
1 54 0.4%
 
(Missing) 5950 44.0%
 

lifecycle
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
3. 121+ days
7122
1. 0 - 80 days
2782
0.Pre-Launch
2357
ValueCountFrequency (%) 
3. 121+ days 7122 52.7%
 
1. 0 - 80 days 2782 20.6%
 
0.Pre-Launch 2357 17.4%
 
2. 81 - 121 days 1264 9.3%
 
Max length16
Mean length12.99090573
Min length12
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

New_Week_Since_Launch
Highly correlated

This variable is highly correlated with days_since_launch and should be ignored for analysis

Correlation0.9998798641

Pkey
Categorical

Distinct count44
Unique (%)0.3%
Missing (%)0.0%
Missing (n)0
Mortal Kombat 11-Game-PS4-North America-United States
 
482
Mortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-United States
 
482
Mortal Kombat 11-Game-Steam-North America-United States
 
482
Other values (41)
12079
ValueCountFrequency (%) 
Mortal Kombat 11-Game-PS4-North America-United States 482 3.6%
 
Mortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-United States 482 3.6%
 
Mortal Kombat 11-Game-Steam-North America-United States 482 3.6%
 
Mortal Kombat 11-Game-PS4-North America-Canada 481 3.6%
 
Mortal Kombat 11 Premium Edition-Game Bundle-Steam-North America-United States 479 3.5%
 
Mortal Kombat 11 Premium Edition-Game Bundle-XB1-North America-United States 477 3.5%
 
Mortal Kombat 11-Game-XB1-North America-United States 477 3.5%
 
Mortal Kombat 11-Game-XB1-North America-Canada 472 3.5%
 
Mortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-Canada 459 3.4%
 
Mortal Kombat 11-Game-XB1-North America-Mexico 458 3.4%
 
Other values (34) 8776 64.9%
 
Max length79
Mean length61.31275416
Min length46
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

platform
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
PS4
3810
XB1
3765
Steam
3161
ValueCountFrequency (%) 
PS4 3810 28.2%
 
XB1 3765 27.8%
 
Steam 3161 23.4%
 
Switch 2789 20.6%
 
Max length6
Mean length4.086062847
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesFalse
Contains non-wordsFalse

Post.Holiday.Flag
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)44.0%
Missing (n)5950
0
7233
1
 
342
(Missing)
5950
ValueCountFrequency (%) 
0 7233 53.5%
 
1 342 2.5%
 
(Missing) 5950 44.0%
 

Pre.Holiday.Flag
Boolean

Distinct count3
Unique (%)< 0.1%
Missing (%)44.0%
Missing (n)5950
0
6973
1
 
602
(Missing)
5950
ValueCountFrequency (%) 
0 6973 51.6%
 
1 602 4.5%
 
(Missing) 5950 44.0%
 

Price
Numeric

Distinct count28
Unique (%)0.2%
Missing (%)86.7%
Missing (n)11724
Infinite (%)0.0%
Infinite (n)0
Mean53.58662543
Minimum23.996
Maximum59.99
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum23.996
5-th percentile23.996
Q156.3906
Median59.99
Q359.99
95-th percentile59.99
Maximum59.99
Range35.994
Interquartile range3.5994

Descriptive statistics

Standard deviation12.02905196
Coef of variation0.2244786243
Kurtosis0.8192923135
Mean53.58662543
MAD9.604623896
Skewness-1.573142727
Sum96509.5124
Variance144.6980911
Memory size105.8 KiB
Histogram
Histogram with fixed size bins (bins=28)
ValueCountFrequency (%) 
59.99 1350 10.0%
 
23.996 104 0.8%
 
29.995 95 0.7%
 
35.994 72 0.5%
 
49.7917 48 0.4%
 
44.9925 39 0.3%
 
41.993 19 0.1%
 
24.5959 18 0.1%
 
45.5924 14 0.1%
 
25.1958 14 0.1%
 
Other values (17) 28 0.2%
 
(Missing) 11724 86.7%
 

Minimum 5 values

ValueCountFrequency (%) 
23.996 104 0.8%
 
24.5959 18 0.1%
 
25.1958 14 0.1%
 
26.3956 2 < 0.1%
 
26.9955 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
59.99 1350 10.0%
 
56.3906 1 < 0.1%
 
55.1908 1 < 0.1%
 
53.3911 1 < 0.1%
 
52.1913 1 < 0.1%
 

Promo
Categorical

Distinct count43
Unique (%)0.3%
Missing (%)79.7%
Missing (n)10774
black friday sale
 
224
psn global holiday sale
 
162
sale of the dead/halloween americas
 
156
Other values (39)
2209
(Missing)
10774
ValueCountFrequency (%) 
black friday sale 224 1.7%
 
psn global holiday sale 162 1.2%
 
sale of the dead/halloween americas 156 1.2%
 
winter sale 136 1.0%
 
countdown 135 1.0%
 
steam summer sale 125 0.9%
 
wb publisher sale 103 0.8%
 
mk 11 free play / pub sale 99 0.7%
 
sony summer sale 89 0.7%
 
joker promo 81 0.6%
 
Other values (32) 1441 10.7%
 
(Missing) 10774 79.7%
 
Max length47
Mean length6.420628466
Min length3
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

pweek
Categorical

Distinct count2178
Unique (%)16.1%
Missing (%)0.0%
Missing (n)0
Mortal Kombat 11-Game-PS4-North America-Canada-0
 
13
Mortal Kombat 11-Game-PS4-North America-Mexico-0
 
13
Mortal Kombat 11-Game-XB1-North America-Mexico-0
 
13
Other values (2175)
13486
ValueCountFrequency (%) 
Mortal Kombat 11-Game-PS4-North America-Canada-0 13 0.1%
 
Mortal Kombat 11-Game-PS4-North America-Mexico-0 13 0.1%
 
Mortal Kombat 11-Game-XB1-North America-Mexico-0 13 0.1%
 
Mortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-Canada-0 13 0.1%
 
Mortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-United States-0 13 0.1%
 
Mortal Kombat 11-Game-XB1-North America-Canada-0 13 0.1%
 
Mortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-Mexico-0 13 0.1%
 
Mortal Kombat 11 Premium Edition-Game Bundle-Steam-North America-Mexico-0 13 0.1%
 
Mortal Kombat 11-Game-Switch-North America-Mexico-0 13 0.1%
 
Mortal Kombat 11 Premium Edition-Game Bundle-XB1-North America-Canada-0 13 0.1%
 
Other values (2168) 13395 99.0%
 
Max length82
Mean length64.20118299
Min length48
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

revenue_usd
Numeric

Distinct count9723
Unique (%)71.9%
Missing (%)0.0%
Missing (n)0
Infinite (%)0.0%
Infinite (n)0
Mean5833.434703
Minimum-159.271
Maximum1355393.641
Zeros (%)0.7%
Mini histogram

Quantile statistics

Minimum-159.271
5-th percentile41.05660968
Q1138.18203
Median539.21091
Q32379.762
95-th percentile21726.8562
Maximum1355393.641
Range1355552.912
Interquartile range2241.57997

Descriptive statistics

Standard deviation34568.51938
Coef of variation5.925928915
Kurtosis614.2325785
Mean5833.434703
MAD8394.640377
Skewness21.3810817
Sum78897204.36
Variance1194982532
Memory size105.8 KiB
Histogram
Histogram with fixed size bins (bins=50)
Histogram
Histogram with variable size bins (bins=[-1.59271000e+02 -6.98302850e+01 -6.48410000e+01 -4.42330000e+01 -4.10856600e+01 ... 7.27116915e+04 1.12598878e+05 2.74970164e+05 6.48312787e+05 1.35539364e+06], "bayesian blocks" binning strategy used)
ValueCountFrequency (%) 
0 96 0.7%
 
139.986 62 0.5%
 
83.979 59 0.4%
 
41.993 57 0.4%
 
69.993 53 0.4%
 
55.986 53 0.4%
 
111.972 51 0.4%
 
209.979 49 0.4%
 
83.986 47 0.3%
 
125.979 47 0.3%
 
Other values (9713) 12951 95.8%
 

Minimum 5 values

ValueCountFrequency (%) 
-159.271 1 < 0.1%
 
-138.565 1 < 0.1%
 
-134.52439 1 < 0.1%
 
-130.0852 1 < 0.1%
 
-125.671 1 < 0.1%
 

Maximum 5 values

ValueCountFrequency (%) 
1355393.641 1 < 0.1%
 
1332017.96 1 < 0.1%
 
1130793.713 1 < 0.1%
 
1016858.304 1 < 0.1%
 
876981.812 1 < 0.1%
 

sku_name
Categorical

Distinct count4
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Mortal Kombat 11
5043
Mortal Kombat 11 Premium Edition
4783
Mortal Kombat 11 - Kombat Pack
3696
ValueCountFrequency (%) 
Mortal Kombat 11 5043 37.3%
 
Mortal Kombat 11 Premium Edition 4783 35.4%
 
Mortal Kombat 11 - Kombat Pack 3696 27.3%
 
Matinee Skin Pack 3 < 0.1%
 
Max length32
Mean length25.48428835
Min length16
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

sku_name.1
Categorical

Distinct count5
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Mortal Kombat 11-Game
5043
Mortal Kombat 11 Premium Edition-Game Bundle
4614
Mortal Kombat 11 - Kombat Pack-DLC
3696
Other values (2)
 
172
ValueCountFrequency (%) 
Mortal Kombat 11-Game 5043 37.3%
 
Mortal Kombat 11 Premium Edition-Game Bundle 4614 34.1%
 
Mortal Kombat 11 - Kombat Pack-DLC 3696 27.3%
 
Mortal Kombat 11 Premium Edition-Game 169 1.2%
 
Matinee Skin Pack-Game 3 < 0.1%
 
Max length44
Mean length32.59903882
Min length21
Contains charsTrue
Contains digitsTrue
Contains spacesTrue
Contains non-wordsTrue

sku_type
Categorical

Distinct count3
Unique (%)< 0.1%
Missing (%)0.0%
Missing (n)0
Game
5215
Game Bundle
4614
DLC
3696
ValueCountFrequency (%) 
Game 5215 38.6%
 
Game Bundle 4614 34.1%
 
DLC 3696 27.3%
 
Max length11
Mean length6.114750462
Min length3
Contains charsTrue
Contains digitsFalse
Contains spacesTrue
Contains non-wordsTrue

transaction_date
Categorical

Distinct count483
Unique (%)3.6%
Missing (%)0.0%
Missing (n)0
29-12-2019
 
39
12/12/2019
 
39
25-01-2020
 
39
Other values (480)
13408
ValueCountFrequency (%) 
29-12-2019 39 0.3%
 
12/12/2019 39 0.3%
 
25-01-2020 39 0.3%
 
27-12-2019 38 0.3%
 
24-12-2019 38 0.3%
 
25-04-2019 38 0.3%
 
22-12-2019 38 0.3%
 
25-12-2019 38 0.3%
 
1/2/2020 38 0.3%
 
30-12-2019 38 0.3%
 
Other values (473) 13142 97.2%
 
Max length10
Mean length9.421072089
Min length8
Contains charsFalse
Contains digitsTrue
Contains spacesFalse
Contains non-wordsTrue

units_base
Numeric

Distinct count35
Unique (%)0.3%
Missing (%)1.3%
Missing (n)182
Infinite (%)0.0%
Infinite (n)0
Mean3186.163531
Minimum2
Maximum31720
Zeros (%)0.0%
Mini histogram

Quantile statistics

Minimum2
5-th percentile11
Q172
Median322
Q31340
95-th percentile25967
Maximum31720
Range31718
Interquartile range1268

Descriptive statistics

Standard deviation7422.637995
Coef of variation2.329647528
Kurtosis8.037635137
Mean3186.163531
MAD4383.428712
Skewness3.038363616
Sum42512980
Variance55095554.81
Memory size105.8 KiB
Histogram
Histogram with fixed size bins (bins=35)
ValueCountFrequency (%) 
14 582 4.3%
 
39 539 4.0%
 
4497 482 3.6%
 
25967 482 3.6%
 
6327 482 3.6%
 
1340 481 3.6%
 
702 479 3.5%
 
31720 477 3.5%
 
6002 477 3.5%
 
1012 472 3.5%
 
Other values (24) 8390 62.0%
 

Minimum 5 values

ValueCountFrequency (%) 
2 130 1.0%
 
7 305 2.3%
 
11 239 1.8%
 
14 582 4.3%
 
17 333 2.5%
 

Maximum 5 values

ValueCountFrequency (%) 
31720 477 3.5%
 
25967 482 3.6%
 
6420 360 2.7%
 
6327 482 3.6%
 
6002 477 3.5%
 

units_sold
Highly correlated

This variable is highly correlated with revenue_usd and should be ignored for analysis

Correlation0.9636180616

Correlations

Missing values

Sample

First rows

asp_newbase_aspBlack.FridayChristmas.Flagday_of_Weekdays_since_launchDiscount_finaldlc_event_flagEventF_KeyFB_SpendsFB_Spends_Adstock_0.173Festival.FlagFiscal_MonthFiscal_WeekFiscal_YearFree.Trial.WeekFree.Trial.Week.Lag1Free.Trial.Week.Lag2game_namegeo_regiongeo_subregionHalloweenHolidaylifecycleNew_Week_Since_LaunchPkeyplatformPost.Holiday.FlagPre.Holiday.FlagPricePromopweekrevenue_usdsku_namesku_name.1sku_typetransaction_dateunits_baseunits_sold
041.87400041.609054NaNNaNThursday-1380%0NaNMortal Kombat 11-Game-Steam-North America-Canada--13800.0NaN12492018NaNNaNNaNMortal Kombat 11North AmericaCanadaNaNNaN0.Pre-Launch-20Mortal Kombat 11-Game-Steam-North America-CanadaSteamNaNNaNNaNNaNMortal Kombat 11-Game-Steam-North America-Canada--1983.748Mortal Kombat 11Mortal Kombat 11-GameGame6/12/2018448.02
141.99300041.993335NaNNaNThursday-1380%0NaNMortal Kombat 11-Game-Steam-North America-United States--13800.0NaN12492018NaNNaN0.0Mortal Kombat 11North AmericaUnited StatesNaNNaN0.Pre-Launch-20Mortal Kombat 11-Game-Steam-North America-United StatesSteamNaNNaN59.99NaNMortal Kombat 11-Game-Steam-North America-United States--19755.874Mortal Kombat 11Mortal Kombat 11-GameGame6/12/20184497.018
268.37600067.537143NaNNaNThursday-1380%0NaNMortal Kombat 11 Premium Edition-Game Bundle-Steam-North America-Canada--13800.0NaN12492018NaNNaNNaNMortal Kombat 11North AmericaCanadaNaNNaN0.Pre-Launch-20Mortal Kombat 11 Premium Edition-Game Bundle-Steam-North America-CanadaSteamNaNNaNNaNNaNMortal Kombat 11 Premium Edition-Game Bundle-Steam-North America-Canada--19136.752Mortal Kombat 11 Premium EditionMortal Kombat 11 Premium Edition-Game BundleGame Bundle6/12/201862.02
369.99300069.993000NaNNaNThursday-1380%0NaNMortal Kombat 11 Premium Edition-Game Bundle-Steam-North America-United States--13800.0NaN12492018NaNNaNNaNMortal Kombat 11North AmericaUnited StatesNaNNaN0.Pre-Launch-20Mortal Kombat 11 Premium Edition-Game Bundle-Steam-North America-United StatesSteamNaNNaNNaNNaNMortal Kombat 11 Premium Edition-Game Bundle-Steam-North America-United States--191539.846Mortal Kombat 11 Premium EditionMortal Kombat 11 Premium Edition-Game BundleGame Bundle6/12/2018702.022
442.07233342.2735120.00.0Friday-1370%0NaNMortal Kombat 11-Game-PS4-North America-Canada--13700.00.0124920180.00.0NaNMortal Kombat 11North AmericaCanada0.00.00.Pre-Launch-20Mortal Kombat 11-Game-PS4-North America-CanadaPS40.00.0NaNNaNMortal Kombat 11-Game-PS4-North America-Canada--19126.217Mortal Kombat 11Mortal Kombat 11-GameGame7/12/20181340.03
541.99300041.9930000.00.0Friday-1370%0NaNMortal Kombat 11-Game-PS4-North America-Mexico--13700.00.0124920180.00.0NaNMortal Kombat 11North AmericaMexico0.00.00.Pre-Launch-20Mortal Kombat 11-Game-PS4-North America-MexicoPS40.00.0NaNNaNMortal Kombat 11-Game-PS4-North America-Mexico--1983.986Mortal Kombat 11Mortal Kombat 11-GameGame7/12/2018186.02
643.69920043.5473380.00.0Friday-1370%0NaNMortal Kombat 11-Game-PS4-North America-United States--13700.00.0124920180.00.00.0Mortal Kombat 11North AmericaUnited States0.00.00.Pre-Launch-20Mortal Kombat 11-Game-PS4-North America-United StatesPS40.00.059.99NaNMortal Kombat 11-Game-PS4-North America-United States--194588.416Mortal Kombat 11Mortal Kombat 11-GameGame7/12/201825967.0105
768.37191768.6188910.00.0Friday-1370%0NaNMortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-Canada--13700.00.0124920180.00.0NaNMortal Kombat 11North AmericaCanada0.00.00.Pre-Launch-20Mortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-CanadaPS40.00.0NaNNaNMortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-Canada--19820.463Mortal Kombat 11 Premium EditionMortal Kombat 11 Premium Edition-Game BundleGame Bundle7/12/2018322.012
869.99300069.9930000.00.0Friday-1370%0NaNMortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-Mexico--13700.00.0124920180.00.0NaNMortal Kombat 11North AmericaMexico0.00.00.Pre-Launch-20Mortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-MexicoPS40.00.0NaNNaNMortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-Mexico--19209.979Mortal Kombat 11 Premium EditionMortal Kombat 11 Premium Edition-Game BundleGame Bundle7/12/201872.03
972.48266772.6990870.00.0Friday-1370%0NaNMortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-United States--13700.00.0124920180.00.0NaNMortal Kombat 11North AmericaUnited States0.00.00.Pre-Launch-20Mortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-United StatesPS40.00.0NaNNaNMortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-United States--198263.024Mortal Kombat 11 Premium EditionMortal Kombat 11 Premium Edition-Game BundleGame Bundle7/12/20186327.0114

Last rows

asp_newbase_aspBlack.FridayChristmas.Flagday_of_Weekdays_since_launchDiscount_finaldlc_event_flagEventF_KeyFB_SpendsFB_Spends_Adstock_0.173Festival.FlagFiscal_MonthFiscal_WeekFiscal_YearFree.Trial.WeekFree.Trial.Week.Lag1Free.Trial.Week.Lag2game_namegeo_regiongeo_subregionHalloweenHolidaylifecycleNew_Week_Since_LaunchPkeyplatformPost.Holiday.FlagPre.Holiday.FlagPricePromopweekrevenue_usdsku_namesku_name.1sku_typetransaction_dateunits_baseunits_sold
1351568.40309067.7333640.00.0Tuesday3430%0NaNMortal Kombat 11 Premium Edition-Game Bundle-XB1-North America-Canada-3430112.930.031320200.00.0NaNMortal Kombat 11North AmericaCanada0.00.03. 121+ days49Mortal Kombat 11 Premium Edition-Game Bundle-XB1-North America-CanadaXB10.00.0NaNNaNMortal Kombat 11 Premium Edition-Game Bundle-XB1-North America-Canada-49136.80618Mortal Kombat 11 Premium EditionMortal Kombat 11 Premium Edition-Game BundleGame Bundle31-03-2020279.02
1351673.16050072.3517940.00.0Tuesday3430%0NaNMortal Kombat 11 Premium Edition-Game Bundle-XB1-North America-Mexico-3430112.930.031320200.00.0NaNMortal Kombat 11North AmericaMexico0.00.03. 121+ days49Mortal Kombat 11 Premium Edition-Game Bundle-XB1-North America-MexicoXB10.00.0NaNNaNMortal Kombat 11 Premium Edition-Game Bundle-XB1-North America-Mexico-4973.16050Mortal Kombat 11 Premium EditionMortal Kombat 11 Premium Edition-Game BundleGame Bundle31-03-2020237.01
1351762.99300069.9930000.00.0Tuesday34310%0NaNMortal Kombat 11 Premium Edition-Game Bundle-XB1-North America-United States-3430112.930.031320200.00.0NaNMortal Kombat 11North AmericaUnited States0.00.03. 121+ days49Mortal Kombat 11 Premium Edition-Game Bundle-XB1-North America-United StatesXB10.00.0NaNNaNMortal Kombat 11 Premium Edition-Game Bundle-XB1-North America-United States-494094.54500Mortal Kombat 11 Premium EditionMortal Kombat 11 Premium Edition-Game BundleGame Bundle31-03-20206002.065
1351843.69400043.5473380.00.0Wednesday3440%0NaNMortal Kombat 11-Game-PS4-North America-United States-344019.540.041420200.00.00.0Mortal Kombat 11North AmericaUnited States0.00.03. 121+ days49Mortal Kombat 11-Game-PS4-North America-United StatesPS40.00.059.99NaNMortal Kombat 11-Game-PS4-North America-United States-49218.47000Mortal Kombat 11Mortal Kombat 11-GameGame1/4/202025967.05
1351929.37550029.1144640.00.0Wednesday3440%0NaNMortal Kombat 11 - Kombat Pack-DLC-PS4-North America-United States-344019.540.041420200.00.0NaNMortal Kombat 11North AmericaUnited States0.00.03. 121+ days49Mortal Kombat 11 - Kombat Pack-DLC-PS4-North America-United StatesPS40.00.0NaNNaNMortal Kombat 11 - Kombat Pack-DLC-PS4-North America-United States-49117.50200Mortal Kombat 11 - Kombat PackMortal Kombat 11 - Kombat Pack-DLCDLC1/4/20202046.04
1352066.23575072.6990870.00.0Wednesday3449%0NaNMortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-United States-344019.540.041420200.00.0NaNMortal Kombat 11North AmericaUnited States0.00.03. 121+ days49Mortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-United StatesPS40.00.0NaNNaNMortal Kombat 11 Premium Edition-Game Bundle-PS4-North America-United States-49264.94300Mortal Kombat 11 Premium EditionMortal Kombat 11 Premium Edition-Game BundleGame Bundle1/4/20206327.04
1352138.25571348.063467NaNNaNWednesday34420%0NaNMortal Kombat 11-Game-Switch-North America-Mexico-344019.54NaN4142020NaNNaNNaNMortal Kombat 11North AmericaMexicoNaNNaN3. 121+ days49Mortal Kombat 11-Game-Switch-North America-MexicoSwitchNaNNaNNaNNaNMortal Kombat 11-Game-Switch-North America-Mexico-490.00000Mortal Kombat 11Mortal Kombat 11-GameGame1/4/2020108.01
1352241.99300041.993000NaNNaNWednesday3440%0NaNMortal Kombat 11-Game-Switch-North America-United States-344019.54NaN4142020NaNNaN0.0Mortal Kombat 11North AmericaUnited StatesNaNNaN3. 121+ days49Mortal Kombat 11-Game-Switch-North America-United StatesSwitchNaNNaN59.99NaNMortal Kombat 11-Game-Switch-North America-United States-490.00000Mortal Kombat 11Mortal Kombat 11-GameGame1/4/20206420.02
1352327.99300027.993000NaNNaNWednesday3440%0NaNMortal Kombat 11 - Kombat Pack-DLC-Switch-North America-United States-344019.54NaN4142020NaNNaNNaNMortal Kombat 11North AmericaUnited StatesNaNNaN3. 121+ days49Mortal Kombat 11 - Kombat Pack-DLC-Switch-North America-United StatesSwitchNaNNaNNaNNaNMortal Kombat 11 - Kombat Pack-DLC-Switch-North America-United States-490.00000Mortal Kombat 11 - Kombat PackMortal Kombat 11 - Kombat Pack-DLCDLC1/4/2020731.01
1352462.99300069.993000NaNNaNWednesday34410%0NaNMortal Kombat 11 Premium Edition-Game Bundle-Switch-North America-United States-344019.54NaN4142020NaNNaNNaNMortal Kombat 11North AmericaUnited StatesNaNNaN3. 121+ days49Mortal Kombat 11 Premium Edition-Game Bundle-Switch-North America-United StatesSwitchNaNNaNNaNNaNMortal Kombat 11 Premium Edition-Game Bundle-Switch-North America-United States-490.00000Mortal Kombat 11 Premium EditionMortal Kombat 11 Premium Edition-Game BundleGame Bundle1/4/2020969.01